Amanda Carta ✭✭✭✭

Overview

Overview

Roles	Member
Badges	10

About Me

About Me

Not much happening here, yet.

Analytics

31

Posts

55

Visits

199

Points

Feb 15, 2024

Join Date

Jul 11, 2024

Last Active

Reactions

• Insightful 6

  6
• Vote Up 7

  7
• Awesome 5

  5

• Activity
• Discussions6
• Comments25

• Re: The form was successfully submitted, but the data did not enter the sheet.

  Amanda Carta

  06/21/24
  Giving credit to Brian Campbell for these questions :) Please check the following things first.
  1 ·

• Re: Leave field Blank when using IF formula, on Date Row.

  Amanda Carta

  02/16/24
  add an "IF" statement to the formula. I know you said you tried it but I found I didn't close it out before adding the ,"" at the end. =IF(ISBLANK([Expire Date]@row), "")
  1 ·

• Re: Leave field Blank when using IF formula, on Date Row.

  Amanda Carta

  02/16/24
  I'll recreate exactly what you have and you can just copy/paste and let me know :)
  1 ·

• Re: Leave field Blank when using IF formula, on Date Row.

  Amanda Carta

  02/16/24
  Change the order of your formula =IF(ISBLANK([Expire Date]@row), "", IF([Expire Date]@row < TODAY(+30), "Red", IF([Expire Date]@row < TODAY(+60), "Yellow", IF([Exp…
  1 ·

• Re: Leave field Blank when using IF formula, on Date Row.

  Amanda Carta

  02/16/24
  My concern though is what if you have a count of days that = 61-90. It currently would have it blank
  1 ·

Next